CREATE PROCEDURE [dbo].[sp_demoDataInsert]
AS
BEGIN
	declare @beginnum integer
	declare @endnum integer
	
	set @beginnum=1; 
	set @endnum=500001; 
	 WHILE (@beginnum <=@endnum)
		BEGIN
			INSERT INTO t_demo_entity ( intfield ,booleanfield,bytefield,charField,doubleField,floatField,longField,shortField) 
										 VALUES     ( 1 ,0,10,'c',0.1,0.2,2,3);
			SET @beginnum = @beginnum + 1
		END
END
GO


/****** 对象:  Index [index_demo_desc]    脚本日期: 04/11/2013 13:09:21 *****
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[t_demo_entity]') AND name = N'index_demo_desc')
*/
CREATE NONCLUSTERED INDEX [index_demo_desc] ON [dbo].[t_demo_entity] 
(
	[demoId] DESC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
GO

/****** 对象:  Index [index_demoId]    脚本日期: 04/11/2013 13:09:21 *****
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[t_demo_entity]') AND name = N'index_demoId')
*/
CREATE NONCLUSTERED INDEX [index_demoId] ON [dbo].[t_demo_entity] 
(
	[demoId] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
GO

/****** 对象:  Index [index_stringField]    脚本日期: 04/11/2013 13:09:21 *****
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[t_demo_entity]') AND name = N'index_stringField')
*/
CREATE NONCLUSTERED INDEX [index_stringField] ON [dbo].[t_demo_entity] 
(
	[stringField] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
GO